package net.trustie.dao;

import net.trustie.model.softpedia_Model;

import org.apache.ibatis.annotations.Insert;

public interface SoftPedia_Dao {
	
	/*标准表中的字段*//*+ "insert into t_project (`deal_name`,`name`,`description`,`last_update_time`,
	 * `registered_time`,`followers_num`,`url`,`urlMD5`,`pageMD5`,`language`,`tags`,`contributors_num`,
	 * `monitor`,`status`,`download_num`,`visit_num`,`category`,`crawled_time`,`history`,`source`,`license`,`platform`")*/
	
	/*标准表中的字段*//*+ "insert into t_project (`deal_name`,``,``,`last_update_time`,
	 * ``,`followers_num`,``,`urlMD5`,`pageMD5`,`language`,``,`contributors_num`,
	 * `monitor`,`status`,``,`visit_num`,``,`crawled_time`,`history`,`source`")*/
	
	@Insert("insert into softpedia"
			+ "(`name`,`url`,`project_context`,`description`,`download_num`,"
			+ "`registered_time`,`tags`,`platform`,`author`,`author_url`,`category`,`user_rate_num`,`license`,`extractTime`)"
			
			+ "values(#{project_name},#{project_url},#{project_context},#{project_description},#{download_num},"
			+ "#{post_time},#{tag},#{system},#{author},#{author_url},#{category},#{user_rate_num},#{licence_type},#{extractTime})")
	
	  /*1标准表中独有,设置为允许为空,INSERT需要补齐*/
    /*2与标准表对应字段*/
   /*3原社区中独有保留字段*/ 
	
			/*@Insert("insert into softpedia"
			+ "(`2name`,`2url`,`3project_context`,`2description`,`2download_num`,"
			+ "`2registered_time`,`2tags`,`2platform`,`3author`,`3author_url`,`2category`,`3user_rate_num`,`2license`,`3extractTime`,"
			+ "`deal_name`,`last_update_time`,`followers_num`,`urlMD5`,`pageMD5`,`language`,`contributors_num`,`monitor`,`status`,"
			+ "`visit_num`,`crawled_time`,`history`,`source`)"*/
	
	
        
			public int add(softpedia_Model sp);
}
